Building and Evolving Data Warehousing and Business Intelligence artefacts: the Case of Sysco

This paper investigates the use of data warehouse and business intelligence capabilities to integrate with customers in the supply chain and improve insights into customer sales. By making that same data warehouse sales information available to customers, this paper explores how the data warehouse can provide additional value to those customers, eliminating asymmetries of information in the supply chain. In addition, this paper investigates the evolution of data warehousing into business intelligence, expanding sales information to include marketing associate performance analysis generated for internal use. Further, this paper also examines a methodology that was used for building a business intelligence system. Finally, this paper investigates what appears to be a business intelligence driven focus on enterprise resource planning systems. These issues are illustrated using real world data warehousing and business intelligence artifacts developed at SYSCO.